<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Disk Details</title>
</head>

<style type="text/css">
@import "flip-tabs.css";
</style>
<script type="text/javascript" src="flip-tab.js">
</script>
<script type="text/javascript">
  document.write('<style type="text/css">');  
  document.write('div.flip-tabs div{display:none;}<');
  document.write('/s'+'tyle>'); </script>

</head>
<body style="background-color:darkseagreen;">
    <image align="right" src=Capture.jpg width=100 height=100 font size=4 color=black>

<h1 align="center"><font color=blue>STORAGE INVENTORY</font></h1>


<table cellpadding=6 border=2 width=750>


<div id="flip-tabs">
        <ul id="flip-navigation">

             <li> <a href="Aggregade.jsp" id="tab-2">Aggregade Details</a> </li>
      		<li> <a href="Disk.jsp" id="tab-5">Disk Details</a> </li>
     		 <li> <a href="vol.jsp" id="tab-1">volume Details</a> </li>
     		 <li><a href="lun.jsp" id="tab-3">Lun Details</a> </li>
      		<li> <a href="Qtree.jsp" id="tab-4">Qtree Details</a> </li>
             <li> <a href="HomePage.jsp" id="tab-6">Home</a> </li>
            
   
    </ul>
    <div id="flip-container">
    </div>
    
 </div> 


  <tr>
  <th bgcolor="#5D7B9D"><font color="#fff">diskname</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">owner</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">pool</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">snum</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">aggr</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">raidtype</font></th>
 
  
  </tr>
  
  
<font size="4" color="blue">Disk Details</font> 
 <%@ page import= "java.sql.*;"%>
<%  Connection con=null;
      Statement st=null;
     
      ResultSet rs=null;
      PreparedStatement pt=null;
      
 
	String diskname,owner,pool,snum,aggr,raidtype;
try
	{
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	con = DriverManager.getConnection("jdbc:mysql://localhost/netapp", "root", "rr");
	
	
                pt=con.prepareStatement("select * from disk");
	  rs=pt.executeQuery();
              while( rs.next())
	  {
          diskname=rs.getString(1);
          owner=rs.getString(2);
          pool=rs.getString(3);
          snum=rs.getString(4);
          aggr=rs.getString(5);
          raidtype=rs.getString(6);

         
	  
	  out.println("<TR>");
      
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + diskname +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + owner +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + pool +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + snum +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + aggr +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + raidtype +"</font>"+ "</TD>");
      out.println("</TR>");

	  
     
	  
	}
              }
catch(Exception e)
{
 	out.println(e);
}
%>

 

</TABLE>;
</body>
</html>